package com.app.mapper;

import com.app.model.DividedIntoRecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author yoominic
 * @since 2024-05-30
 */
public interface DividedIntoRecordMapper extends BaseMapper<DividedIntoRecord> {

    IPage<DividedIntoRecord> pages(Page page,
                                   @Param("beginTime") String beginTime,
                                   @Param("endTime") String endTime,
                                   @Param("areaId") String areaId,
                                   @Param("city") String city,
                                   @Param("keyword") String keyword,
                                   @Param("type") Integer type);

    Map<String, Object> dataStatistics(@Param("beginTime") String beginTime,
                                       @Param("endTime") String endTime,
                                       @Param("areaId") String areaId,
                                       @Param("city") String city,
                                       @Param("keyword") String keyword,
                                       @Param("type") Integer type);

    BigDecimal queryPlatformDrawing(@Param("beginTime") String beginTime,
                                    @Param("endTime") String endTime);

    BigDecimal sumPlatformDrawing();
}
